﻿<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <!--DXMETADATA start type="MetaCharset" --><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8"><!--DXMETADATA end-->
    <meta http-equiv="X-UA-Compatible" value="IE=9" />

    <!--DXMETADATA start type="Literal" condition="helpversion:value=3" value="<meta name=""Microsoft.Help.SelfBranded"" content=""true"" />" --><!--DXMETADATA end-->
    <!--DXMETADATA start type="ItemTitle" format="<title>%%ProjectTitle%% - %%ItemTitle%%</title>" --><title>SpreadJS Documentation - Sheet and Sheets Elements</title><!--DXMETADATA end-->
    <!--DXMETADATA start type="ItemTitle" format="<meta name=""Title"" content=""%%ProjectTitle%% - %%ItemTitleNoQuotes%%""/>" --><meta name="Title" content="SpreadJS Documentation - Sheet and Sheets Elements"/><!--DXMETADATA end-->
    
    <!--DXMETADATA start type="PackageLink" packagename="jquery" filetype="script" firstlinkattributes="id=""mshs_support_script"""--><script src="template/packages/jquery/script/default/jquery-1.11.3.min.js" type="text/javascript" id="mshs_support_script"></script><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="jquery-ui" filetype="script"--><script src="template/packages/jquery-ui/script/default/jquery-ui-1.11.4.min.js" type="text/javascript"></script><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="jquery-ui" filetype="css"--><link rel="stylesheet" type="text/css" href="template/packages/jquery-ui/css/default/jquery-ui-1.11.4.css"></link><!--DXMETADATA end-->
    <!--DXMETADATA start type="TemplateSettingsJson" format="<script type=""text/javascript"">var Innovasys=(Innovasys||{});$.extend(true,Innovasys,{settings:{isHideBodyDuringLoadDisabled:true,dynamictoc:{isEnabled:true},inthistopic:{isSupported:true},dynamicstyles:{isDynamicWordWrapEnabled:true}}},{settings:%%TemplateSettingsJson%%});</script>" --><script type="text/javascript">var Innovasys=(Innovasys||{});$.extend(true,Innovasys,{settings:{isHideBodyDuringLoadDisabled:true,dynamictoc:{isEnabled:true},inthistopic:{isSupported:true},dynamicstyles:{isDynamicWordWrapEnabled:true}}},{settings:{"dynamictoc":{"initialNodeId":"n533","initialNodeContainer":"c0","isResizable":true},"inthistopic":{"isEnabled":true},"currentLocale":"-","isFrameless":true,"navigationKind":"inpage","versions":{"locale":{"currentId":"-"}}}});</script><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="light" filetype="css"--><link rel="stylesheet" type="text/css" href="template/packages/light/css/dynamic-toc.css"></link><!--DXMETADATA end-->
    <!--DXMETADATA start type="Synopsis" StripHtmlTags="True" MaxLength="250" format="<meta name=""Description"" content=""%%Synopsis%%"" />"--><meta name="Description" content="The following table lists the child elements of the sheets element. The sheets element has no attributes." /><!--DXMETADATA end-->
    
    <!--DXMETADATA start type="PackageLink" packagename="plugins-topics" filetype="css"--><link rel="stylesheet" type="text/css" href="template/packages/plugins-topics/css/default/jquery-plugins.css"></link><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="core-topics" filetype="css" firstlinkattributes=" data-mshv2-stylesheet=""/template/packages/core-topics/topics.mshv2.css"" data-mshv1-stylesheet=""/template/packages/core-topics/topics.mshv1.css"" data-responsive-mobile=""template/packages/core-topics/topics.mobile.css"" data-responsive-tablet=""template/packages/core-topics/topics.tablet.css"""--><link rel="stylesheet" type="text/css" href="template/packages/core-topics/css/topics.css"  data-mshv2-stylesheet="/template/packages/core-topics/topics.mshv2.css" data-mshv1-stylesheet="/template/packages/core-topics/topics.mshv1.css" data-responsive-mobile="template/packages/core-topics/topics.mobile.css" data-responsive-tablet="template/packages/core-topics/topics.tablet.css"></link><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="plugins-topics" filetype="script"--><script src="template/packages/plugins-topics/script/default/jquery-plugins.min.js" type="text/javascript"></script><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="core-topics" filetype="script"--><script src="template/packages/core-topics/script/topics.min.js" type="text/javascript"></script><!--DXMETADATA end-->
    
    <!--DXMETADATA start type="TopicId" format="<meta name=""Microsoft.Help.Id"" content=""%%TopicId%%""/>" --><meta name="Microsoft.Help.Id" content="3af2319e-f5a6-4568-a85a-0c1cc2209632"/><!--DXMETADATA end-->
    <!--DXMETADATA start type="TocParentId" format="<meta name=""Microsoft.Help.TocParent"" content=""%%TocParentId%%""/>" --><meta name="Microsoft.Help.TocParent" content="60698b19-303c-4a25-b2e2-85704ba25af0"/><!--DXMETADATA end-->
    <!--DXMETADATA start type="TocOrdinal" format="<meta name=""Microsoft.Help.TocOrder"" content=""%%TocOrdinal%%""/>" --><meta name="Microsoft.Help.TocOrder" content="2"/><!--DXMETADATA end-->
    <meta name="Microsoft.Help.F1" content=""/>
    <meta name="Microsoft.Help.ContentType" content="Concepts" />
    <!--DXMETADATA start type="MshvKeywords" condition="helpversion:value=3" --><!--DXMETADATA end-->
    <!--DXMETADATA start type="MshvMetaTags" condition="helpversion:value=3" --><!--DXMETADATA end-->
    <!--DXMETADATA start type="Help3CatalogLocale" condition="helpversion:value=3" format="<meta name=""Microsoft.Help.Locale"" content=""%%Help3CatalogLocale%%"" />"--><!--DXMETADATA end-->
    <!--DXMETADATA start type="Help3CatalogLocale" condition="helpversion:value=3" format="<meta name=""Microsoft.Help.TopicLocale"" content=""%%Help3CatalogLocale%%"" />"--><!--DXMETADATA end-->
    <!--DXMETADATA start type="Stylesheets" --><link rel="stylesheet" type="text/css" href="stylesheets/hs-simpletab.css"></link><!--DXMETADATA end-->
    <!--DXMETADATA start type="StylePropertyValues" format="<style>%%StylePropertyValues%%</style>" --><style>.i-is-new .i-page-title-text::after, ul#i-dt-root li.i-is-new>a::after { content: "New" }
</style><!--DXMETADATA end-->
    <!--DXMETADATA start type="Scripts" --><!--DXMETADATA end-->
    <!--DXMETADATA start type="DesignTime"--><!--DXMETADATA end-->
    <!--DXMETADATA start type="Scrap" condition="communityenabled" name="_COMMUNITY_PROPERTIES" --><!--DXMETADATA end -->
    <!--DXMETADATA start type="CustomHeadContent" --><link rel="stylesheet" type="text/css" href="template/packages/core-web/css/SP.css">
<script type="text/javascript">
var currentHeader = function() {
    return "spjs";
}
</script>
<script src="template/packages/core-web/script/topNavigation.js"></script>
<script async="" src="https://www.googletagmanager.com/gtm.js?id=GTM-WT462SJ"></script>
<script>
        (function (w, d, s, l, i) {
            w[l] = w[l] || [];
            w[l].push({
                'gtm.start': new Date().getTime()
                , event: 'gtm.js'
            });
            var f = d.getElementsByTagName(s)[0]
                , j = d.createElement(s)
                , dl = l != 'dataLayer' ? '&l=' + l : '';
            j.async = true;
            j.src = 'https://www.googletagmanager.com/gtm.js?id=' + i + dl;
            f.parentNode.insertBefore(j, f);
        })(window, document, 'script', 'dataLayer', 'GTM-WT462SJ');
    </script>
<!--DXMETADATA end-->
</head>

<body>
    <div id="i-before-header-content" class="i-before-header-content">
        
    </div>

    <div id="i-header-container">
        <div id="i-header-content" class="i-header-content i-content-width-container">
            <!--DXMETADATA start type="LogoImage" --><!--DXMETADATA end-->
            <div class="i-project-title"><!--DXMETADATA start type="ProjectTitle" -->SpreadJS Documentation<!--DXMETADATA end--></div>
            <div class="i-search-container">
                <!--DXMETADATA start type="outputfileextension" format="<form action=""websearch%%outputfileextension%%"">" --><form action="websearch.html"><!--DXMETADATA end-->
                <input id="i-search" name="query"/>
                <input type="submit" id="i-search-button" value=""/>
                <!--DXMETADATA start type="Literal" value="</form>" --></form><!--DXMETADATA end-->
            </div>
            <!--DXMETADATA start type="outputfileextension" format="<a id=""i-index-button"" href=""webindex%%outputfileextension%%""></a>" --><a id="i-index-button" href="webindex.html"></a><!--DXMETADATA end-->
        </div>
    </div>
    
    <div class="i-content-width-container"><div class="i-busy-overlay"></div></div>

    <div id="i-breadcrumbs-outer-container" class="i-content-width-container"><!--DXMETADATA start type="Breadcrumbs" scrap="_BREADCRUMBS" --><div class="i-breadcrumbs-container">
<a href="overview.html">SpreadJS Documentation</a>
 / <a href="devguide.html">Developer's Guide</a>
 / <a href="JavaScript Frameworks.html">JavaScript Frameworks</a>
 / <a href="Using Spread.Sheets with AngularJS.html">SpreadJS with AngularJS</a>
 / Sheet and Sheets Elements</div><!--DXMETADATA end --></div>

    

    <div id="i-actions-outer-container" class="i-content-width-container">
        <div id="i-actions-container">
            <div id="i-actions-content" class="i-fixed-to-top">
                <!-- Spacing --> <span class="i-toggle-all-sections i-function-link">
                <label class="i-collapse-all"><!--DXMETADATA start type="Phrase" name="COLLAPSE_ALL" -->Collapse All<!--DXMETADATA end--></label>
                <label class="i-expand-all" style="display: none;"><!--DXMETADATA start type="Phrase" name="EXPAND_ALL" -->Expand All<!--DXMETADATA end--></label>
            </span><!--DXMETADATA start type="Literal" condition="communityenabled" value="%%scrap:name=_COMMUNITY_DROPDOWN%%" --><!--DXMETADATA end -->
                <div class="i-in-this-topic-container">
                    <span class="i-action-group-heading"><!--DXMETADATA start type="Phrase" Name="IN_THIS_TOPIC" -->In This Topic<!--DXMETADATA end--></span>
                </div>
            </div>
        </div>
    </div>

    <div id="i-toc-outer-container" class="i-content-width-container">
        <div id="i-toc-container">
            <div id="i-toc-content" class="i-fixed-to-top">
                <div class="i-toc-content-scroll-container">
                    <div id="i-dynamic-toc-container"><ul id="i-dt-root"></ul></div>
                </div>
            </div>
        </div>
    </div>

    <div id="i-body-content-container" class="i-content-width-container">
        <div id="i-body-content" class="i-body-content">
            <div class="i-page-title"><div class="i-page-title-text"><!--DXMETADATA start type="ItemTitle" -->Sheet and Sheets Elements<!--DXMETADATA end--></div></div>
            <div class="i-in-this-topic-container">
                <span class="i-action-group-heading"><!--DXMETADATA start type="Phrase" Name="IN_THIS_TOPIC" -->In This Topic<!--DXMETADATA end--></span>
            </div>
            <!--DXMETADATA start type="TopicSection" name="BodyText"--><p>The following table lists the child elements of the sheets element. The sheets element has no attributes.</p>

<table>
    <tbody>
        <tr>
            <td><strong>Child Element</strong></td>

            <td><strong>API Reference</strong></td>

            <td><strong>Type</strong></td>
        </tr>

        <tr>
            <td>worksheet</td>

            <td>any</td>

            <td>Worksheet</td>
        </tr>
    </tbody>
</table>

<p>The following table lists the attributes of the sheet element.</p>

<table>
    <tbody>
        <tr>
            <td><strong>Attribute</strong></td>

            <td><strong>API Reference</strong></td>

            <td><strong>Type</strong></td>

            <td><strong>Comment</strong></td>
        </tr>

        <tr>
            <td>allowCellOverflow</td>

            <td>Worksheet.options.allowCellOverflow = value</td>

            <td>boolean</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>clipBoardOptions</td>

            <td>Worksheet.options.clipBoardoptions(value)</td>

            <td>GC.Spread.Sheets.ClipboardPasteOptions</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>colHeaderAutoText</td>

            <td>Worksheet.options.colHeaderAutoText = value</td>

            <td>GC.Spread.Sheets.HeaderAutoText</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>colHeaderAutoTextIndex</td>

            <td>Worksheet.options.colHeaderAutoTextIndex = value</td>

            <td>number</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>colHeaderVisible</td>

            <td>Worksheet.options.colHeaderVisible = value</td>

            <td>boolean</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>currentTheme</td>

            <td>Worksheet.currentTheme(value)</td>

            <td>string</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>dataSource</td>

            <td>Worksheet.setDataSource(value)</td>

            <td>any</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>dataSourceDeepWatch</td>

            <td></td>

            <td>boolean</td>

            <td>This attribute is used for SpreadJS to automatically refresh when the array type data source is changed. When set to true, AngularJS notifies the source of the change and updates SpreadJS; otherwise, does not refresh. The default value is true.</td>
        </tr>

        <tr>
            <td>frozenColumnCount</td>

            <td>Worksheet.frozenColumnCount(value)</td>

            <td>number</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>frozenlineColor</td>

            <td>Worksheet.options.frozenlineColor = value</td>

            <td>string</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>frozenRowCount</td>

            <td>Worksheet.frozenRowCount(value)</td>

            <td>number</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>frozenTrailingColumnCount</td>

            <td>Worksheet.frozenTrailingColumnCount(value)</td>

            <td>number</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>frozenTrailingRowCount</td>

            <td>Worksheet.frozenTrailingRowCount(value)</td>

            <td>number</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>isProtected</td>

            <td>Worksheet.options.isProtected = value</td>

            <td>boolean</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>name</td>

            <td>Worksheet.name(value)</td>

            <td>string</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>rowCount</td>

            <td>Worksheet.setRowCount(value)</td>

            <td>number</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>rowHeaderAutoText</td>

            <td>Worksheet.options.rowHeaderAutoText = value</td>

            <td>GC.Spread.Sheets.HeaderAutoText</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>rowHeaderAutoTextIndex</td>

            <td>Worksheet.options.rowHeaderAutoTextIndex = value</td>

            <td>number</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>rowHeaderVisible</td>

            <td>Worksheet.options.setRowHeaderVisible = value</td>

            <td>boolean</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>selectionBackColor</td>

            <td>Worksheet.options.selectionBackColor = value</td>

            <td>string</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>selectionBorderColor</td>

            <td>Worksheet.options.selectionBorderColor = value</td>

            <td>string</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>selectionPolicy</td>

            <td>Worksheet.selectionPolicy(value)</td>

            <td>GC.Spread.Sheets.SelectionPolicy</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>selectionUnit</td>

            <td>Worksheet.selectionUnit(value)</td>

            <td>GC.Spread.Sheets.SelectionUnit</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>sheetTabColor</td>

            <td>Worksheet.options.sheetTabColor = value</td>

            <td>string</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>showColumnOutline</td>

            <td>Worksheet.showColumnOutline(value)</td>

            <td>boolean</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>showRowOutline</td>

            <td>Worksheet.showRowOutline(value)</td>

            <td>boolean</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>zoom</td>

            <td>Worksheet.zoom(value)</td>

            <td>number</td>

            <td>&nbsp;</td>
        </tr>
    </tbody>
</table>

<p>The following table lists the child elements of the sheet.</p>

<table>
    <tbody>
        <tr>
            <td><strong>Child Element</strong></td>

            <td><strong>API Reference</strong></td>

            <td><strong>Count</strong></td>

            <td><strong>Type</strong></td>

            <td><strong>Comment</strong></td>
        </tr>

        <tr>
            <td>columns</td>

            <td>sheet.columns</td>

            <td>1</td>

            <td>columns</td>

            <td>The columns element can only be added on the sheet element.</td>
        </tr>

        <tr>
            <td>columnOutlines</td>

            <td>Worksheet.columnOutlines</td>

            <td>1</td>

            <td>GC.Spread.Sheets.Outlines.Outline</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>columnHeaderDefaultStyle</td>

            <td>Worksheet.setDefaultStyle(value, SheetArea.colHeader)</td>

            <td>1</td>

            <td>style</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>defaultStyle</td>

            <td>Worksheet.setDefaultStyle(value, SheetArea.viewport)</td>

            <td>1</td>

            <td>style</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>rowHeaderDefaultStyle</td>

            <td>Worksheet.setDefaultStyle(value, SheetArea.rowHeader)</td>

            <td>1</td>

            <td>style</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>rowOutlines</td>

            <td>Worksheet.rowOutlines</td>

            <td>1</td>

            <td>GC.Spread.Sheets.Outlines.Outline</td>

            <td>&nbsp;</td>
        </tr>
    </tbody>
</table><!--DXMETADATA end-->
            <a name="seealsobookmark"></a>
            <!--DXMETADATA start type="FilteredItemList" scrap="CATEGORISED_LINKS" namespace="linkcategory" source="Item" filter="" NoHeader="True" NoFooter="True" format="%%replaceinquotes:value=false%%%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=seealso,caption=""%%phrase:name=SeeAlso%%%%designlist:tagidentifier=seealso,itemtype=See Also%%""%%%%filtereditemlist%%</div>"--><!--DXMETADATA end-->
            
            <div id="i-footer-content" class="i-footer-content">
                <!--DXMETADATA start type="Scrap" condition="communityenabled" name="_COMMUNITY_FOOTER" --><!--DXMETADATA end -->
<!--DXMETADATA start type="Variable" name="CopyrightNotice" format="<p>&nbsp;</p><p>&nbsp;</p><hr style=""height: 1px"" /><p>%%variable%%</p>" --><p>&nbsp;</p><p>&nbsp;</p><hr style="height: 1px" /><p><p>Copyright © 2019 GrapeCity, Inc. All rights reserved.</p>
<p><a href="https://www.grapecity.com/en/forums/winforms-edition" target="_blank">Product Support Forum</a> | <a href="javascript:window.print()">Print this page</a></p>
<ul class="social">
<li><a href="https://www.facebook.com/GrapeCityUS/" target="_blank" class="facebook">&nbsp;</a></li>
<li><a href="https://twitter.com/GrapeCityUS" target="_blank" class="twitter">&nbsp;</a></li>
<li><a href="https://www.linkedin.com/company/grapecity" target="_blank" class="linkedin">&nbsp;</a></li>
</ul>
</p><!--DXMETADATA end -->
<!--DXMETADATA start type="Variable" name="FeedbackLink" format="" --><!--DXMETADATA end-->
            </div>
        </div>
    </div>
        
    <script type="text/javascript">
        $(function () {
            var documentInstance = new Innovasys.Content.Document(document.body);
            documentInstance.load();
        });
    </script>
</body>
</html>
